package com.lagou.service.impl;

import com.lagou.base.StatusCode;
import com.lagou.dao.CourseContentDao;
import com.lagou.dao.impl.CourseContentDaoImpl;
import com.lagou.pojo.Course;
import com.lagou.pojo.Course_Lesson;
import com.lagou.pojo.Course_Section;
import com.lagou.service.CourseContentService;
import com.lagou.utils.DateUtils;
import com.lagou.utils.DruidUtils;
import jdk.jshell.Snippet;
import org.apache.commons.dbutils.QueryRunner;

import java.util.Date;
import java.util.List;

/*
* 课程内容管理 Service层实现类
* */
public class CourseContentServiceImpl implements CourseContentService {

    CourseContentDao contentDao=new CourseContentDaoImpl();

    @Override
    public List<Course_Section> findSectionAndLessonByCourseId(int courseId) {

        List<Course_Section> sections = contentDao.findSectionAndLessonByCourseId(courseId);

        return sections;
    }

    @Override
    public Course findCourseByCourseId(int courseId) {

        Course course = contentDao.findCourseByCourseId(courseId);
        return course;
    }

    @Override
    public String saveSection(Course_Section section) {

        //1.补全章节信息
        section.setStatus(2); //0:隐藏 1:待更新 2:已发布
        String dateFormart = DateUtils.getDateFormart();
        section.setCreate_time(dateFormart);
        section.setUpdate_time(dateFormart);

        //2.调用Dao
        int row = contentDao.saveSection(section);

        //3.根据是否插入成功 封装对应信息
        if(row>0){
            //保存成功
            String result = StatusCode.SUCCESS.toString();
            return result;
        }else{
            //保存失败
            String result = StatusCode.FAIL.toString();
            return result;
        }
    }

    @Override
    public String updateSection(Course_Section section) {

        //1.补全信息
        String dateFormart = DateUtils.getDateFormart();
        section.setUpdate_time(dateFormart);

        //2.调用Dao
        int row = contentDao.updateSection(section);

        //3.判断是否插入成功
        if(row>0){
            //插入成功
            String result = StatusCode.SUCCESS.toString();
            return  result;
        }else{
            String result = StatusCode.FAIL.toString();
            return  result;
        }
    }

    @Override
    public String updateSectionStatus(int id, int status) {

        int row = contentDao.updateSectionStatus(id, status);

        //判断是否修改状态成功
        if(row>0){
            //修改成功
            String result = StatusCode.SUCCESS.toString();
            return result;
        }else{
            //修改失败
            String result = StatusCode.FAIL.toString();
            return result;
        }
    }

    @Override
    public String saveLesson(Course_Lesson lesson) {

        //1.补全信息
        lesson.setStatus(1);
        String dateFormart = DateUtils.getDateFormart();
        lesson.setCreate_time(dateFormart);
        lesson.setUpdate_time(dateFormart);

        //2.调用方法
        int row = contentDao.saveLesson(lesson);

        //3.判断是否保存成功
        if(row>0){
            //保存成功
            String result = StatusCode.SUCCESS.toString();
            return result;
        }else{
            //保存失败
            String result = StatusCode.FAIL.toString();
            return result;
        }
    }

    @Override
    public String updateLesson(Course_Lesson lesson) {

        //1.补全信息
        String dateFormart = DateUtils.getDateFormart();
        lesson.setUpdate_time(dateFormart);

        //2.调用方法
        int row = contentDao.updateLesson(lesson);

        //3.判断是否修改成功
        if(row>0){
            //修改成功
            String result = StatusCode.SUCCESS.toString();
            return result;
        }else{
            //修改失败
            String result = StatusCode.FAIL.toString();
            return result;
        }
    }
}
